/*
 Navicat Premium Data Transfer

 Source Server         : localhost_3306
 Source Server Type    : MySQL
 Source Server Version : 50728
 Source Host           : localhost:3306
 Source Schema         : mall-app

 Target Server Type    : MySQL
 Target Server Version : 50728
 File Encoding         : 65001

 Date: 10/02/2023 22:56:18
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for t_admin
-- ----------------------------
DROP TABLE IF EXISTS `t_admin`;
CREATE TABLE `t_admin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userName` varchar(22) NOT NULL,
  `password` varchar(22) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `email` varchar(255) NOT NULL,
  `createTime` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `email_index` (`email`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_admin
-- ----------------------------
BEGIN;
INSERT INTO `t_admin` (`id`, `userName`, `password`, `name`, `email`, `createTime`) VALUES (1, 'admin', '123', '管理员', '322@qq.com', '2023-02-07 10:13:36');
INSERT INTO `t_admin` (`id`, `userName`, `password`, `name`, `email`, `createTime`) VALUES (3, 'cxyxm', '123', '程序员小铭', '32262@qq.com', '2023-02-07 10:13:45');
INSERT INTO `t_admin` (`id`, `userName`, `password`, `name`, `email`, `createTime`) VALUES (4, 'cxyxmxm', '123', '小铭啊', '3221@qq.com', '2023-02-07 11:25:43');
INSERT INTO `t_admin` (`id`, `userName`, `password`, `name`, `email`, `createTime`) VALUES (6, 'test', '123', '测试', 'test@qq.com', '2023-02-07 14:57:41');
INSERT INTO `t_admin` (`id`, `userName`, `password`, `name`, `email`, `createTime`) VALUES (9, 'test1', '123', '测试1', 'test1@qq.com', '2023-02-07 15:05:34');
INSERT INTO `t_admin` (`id`, `userName`, `password`, `name`, `email`, `createTime`) VALUES (11, 'test3', '123', '测试3', 'test3@qq.com', '2023-02-07 16:07:11');
INSERT INTO `t_admin` (`id`, `userName`, `password`, `name`, `email`, `createTime`) VALUES (12, 'test4', '123', '测试员4', 'test4@qq.com', '2023-02-07 16:11:19');
COMMIT;

-- ----------------------------
-- Table structure for t_bigtype
-- ----------------------------
DROP TABLE IF EXISTS `t_bigtype`;
CREATE TABLE `t_bigtype` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `name` varchar(50) DEFAULT NULL COMMENT '商品大类名称',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `image` varchar(255) DEFAULT NULL COMMENT '大类封面图片',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_bigtype
-- ----------------------------
BEGIN;
INSERT INTO `t_bigtype` (`id`, `name`, `remark`, `image`) VALUES (1, '手机', '手机描述', '1.jpg');
INSERT INTO `t_bigtype` (`id`, `name`, `remark`, `image`) VALUES (2, '电脑平板', '电脑平板描述', '2.jpg');
INSERT INTO `t_bigtype` (`id`, `name`, `remark`, `image`) VALUES (3, '智能穿戴', '智能穿戴描述', '3.jpg');
INSERT INTO `t_bigtype` (`id`, `name`, `remark`, `image`) VALUES (4, '电视', '电视描述', '4.jpg');
INSERT INTO `t_bigtype` (`id`, `name`, `remark`, `image`) VALUES (5, '大家电', '大家电描述', '5.jpg');
INSERT INTO `t_bigtype` (`id`, `name`, `remark`, `image`) VALUES (6, '小家电', '小家电描述', '6.jpg');
INSERT INTO `t_bigtype` (`id`, `name`, `remark`, `image`) VALUES (7, '智能家居', '智能家居描述', '7.jpg');
INSERT INTO `t_bigtype` (`id`, `name`, `remark`, `image`) VALUES (8, '户外出行', '户外出行描述', '8.jpg');
INSERT INTO `t_bigtype` (`id`, `name`, `remark`, `image`) VALUES (9, '日用百货', '日用百货描述', '9.jpg');
INSERT INTO `t_bigtype` (`id`, `name`, `remark`, `image`) VALUES (10, '儿童用品', '儿童用品描述', '10.jpg');
INSERT INTO `t_bigtype` (`id`, `name`, `remark`, `image`) VALUES (12, '113553', '1132131', '20230210034523000000502.jpg');
COMMIT;

-- ----------------------------
-- Table structure for t_comment
-- ----------------------------
DROP TABLE IF EXISTS `t_comment`;
CREATE TABLE `t_comment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `message` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `productId` int(11) DEFAULT NULL COMMENT '所属商品id',
  `sort` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of t_comment
-- ----------------------------
BEGIN;
INSERT INTO `t_comment` (`id`, `message`, `productId`, `sort`) VALUES (1, '这个产品非常棒哦', 14, 1);
INSERT INTO `t_comment` (`id`, `message`, `productId`, `sort`) VALUES (2, '这个手机很棒棒哦', 14, 2);
INSERT INTO `t_comment` (`id`, `message`, `productId`, `sort`) VALUES (3, '这个手机很不错哦', 14, 3);
INSERT INTO `t_comment` (`id`, `message`, `productId`, `sort`) VALUES (4, '不错不错', 14, 4);
INSERT INTO `t_comment` (`id`, `message`, `productId`, `sort`) VALUES (5, '不错不错啊', 14, 5);
COMMIT;

-- ----------------------------
-- Table structure for t_order
-- ----------------------------
DROP TABLE IF EXISTS `t_order`;
CREATE TABLE `t_order` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `orderNo` varchar(100) DEFAULT NULL COMMENT '订单号',
  `userId` varchar(200) DEFAULT NULL COMMENT 'openId微信用户ID',
  `totalPrice` decimal(8,2) DEFAULT NULL COMMENT '总价',
  `address` varchar(300) DEFAULT NULL COMMENT '收货地址',
  `consignee` varchar(20) DEFAULT NULL COMMENT '收货人',
  `telNumber` varchar(20) DEFAULT NULL COMMENT '联系电话',
  `createDate` datetime DEFAULT NULL COMMENT '订单创建日期',
  `payDate` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '订单支付日期',
  `status` int(11) DEFAULT '1' COMMENT '订单状态 0 未支付 1 已经支付',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=132 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_order
-- ----------------------------
BEGIN;
INSERT INTO `t_order` (`id`, `orderNo`, `userId`, `totalPrice`, `address`, `consignee`, `telNumber`, `createDate`, `payDate`, `status`) VALUES (83, 'JAVA20220129103913000000494', 'o30ur5JpAsAUyGBkR0uW4IxvahR8', 5198.00, '广东省广州市海珠区新港中路397号', '张三', '020-81167888', '2022-01-29 10:39:13', '2022-01-27 15:29:06', 1);
INSERT INTO `t_order` (`id`, `orderNo`, `userId`, `totalPrice`, `address`, `consignee`, `telNumber`, `createDate`, `payDate`, `status`) VALUES (84, 'JAVA20220129103913000001494', 'o30ur5JpAsAUyGBkR0uW4IxvahR8', 5198.00, '广东省广州市海珠区新港中路397号', '张三', '020-81167888', '2022-01-29 10:39:13', '2022-01-27 15:29:06', 1);
INSERT INTO `t_order` (`id`, `orderNo`, `userId`, `totalPrice`, `address`, `consignee`, `telNumber`, `createDate`, `payDate`, `status`) VALUES (85, 'JAVA20220129103913000002494', 'o30ur5JpAsAUyGBkR0uW4IxvahR8', 5198.00, '广东省广州市海珠区新港中路397号', '张三', '020-81167888', '2022-01-29 10:39:13', '2022-01-27 15:29:06', 1);
INSERT INTO `t_order` (`id`, `orderNo`, `userId`, `totalPrice`, `address`, `consignee`, `telNumber`, `createDate`, `payDate`, `status`) VALUES (86, 'JAVA20220129103913000003494', 'o30ur5JpAsAUyGBkR0uW4IxvahR8', 5198.00, '广东省广州市海珠区新港中路397号', '张三', '020-81167888', '2022-01-29 10:39:13', '2022-01-27 15:29:06', 1);
INSERT INTO `t_order` (`id`, `orderNo`, `userId`, `totalPrice`, `address`, `consignee`, `telNumber`, `createDate`, `payDate`, `status`) VALUES (87, 'JAVA20220129103913000004494', 'o30ur5JpAsAUyGBkR0uW4IxvahR8', 5198.00, '广东省广州市海珠区新港中路397号', '张三', '020-81167888', '2022-01-29 10:39:13', '2022-01-27 15:29:06', 1);
INSERT INTO `t_order` (`id`, `orderNo`, `userId`, `totalPrice`, `address`, `consignee`, `telNumber`, `createDate`, `payDate`, `status`) VALUES (88, 'JAVA20220129103913000005494', 'o30ur5JpAsAUyGBkR0uW4IxvahR8', 5198.00, '广东省广州市海珠区新港中路397号', '张三', '020-81167888', '2022-01-29 10:39:13', '2022-01-27 15:29:06', 2);
INSERT INTO `t_order` (`id`, `orderNo`, `userId`, `totalPrice`, `address`, `consignee`, `telNumber`, `createDate`, `payDate`, `status`) VALUES (89, 'JAVA20220129103913000006494', 'o30ur5JpAsAUyGBkR0uW4IxvahR8', 5198.00, '广东省广州市海珠区新港中路397号', '张三', '020-81167888', '2022-01-29 10:39:13', '2022-01-27 15:29:06', 2);
INSERT INTO `t_order` (`id`, `orderNo`, `userId`, `totalPrice`, `address`, `consignee`, `telNumber`, `createDate`, `payDate`, `status`) VALUES (90, 'JAVA20220129103913000007494', 'o30ur5JpAsAUyGBkR0uW4IxvahR8', 5198.00, '广东省广州市海珠区新港中路397号', '张三', '020-81167888', '2022-01-29 10:39:13', '2022-01-27 15:29:06', 2);
INSERT INTO `t_order` (`id`, `orderNo`, `userId`, `totalPrice`, `address`, `consignee`, `telNumber`, `createDate`, `payDate`, `status`) VALUES (91, 'JAVA20220129103913000008494', 'o30ur5JpAsAUyGBkR0uW4IxvahR8', 5198.00, '广东省广州市海珠区新港中路397号', '张三', '020-81167888', '2022-01-29 10:39:13', '2022-01-27 15:29:06', 2);
INSERT INTO `t_order` (`id`, `orderNo`, `userId`, `totalPrice`, `address`, `consignee`, `telNumber`, `createDate`, `payDate`, `status`) VALUES (92, 'JAVA20220129103913000009494', 'o30ur5JpAsAUyGBkR0uW4IxvahR8', 5198.00, '广东省广州市海珠区新港中路397号', '张三', '020-81167888', '2022-01-29 10:39:13', '2022-01-27 15:29:06', 2);
INSERT INTO `t_order` (`id`, `orderNo`, `userId`, `totalPrice`, `address`, `consignee`, `telNumber`, `createDate`, `payDate`, `status`) VALUES (93, 'JAVA20220129103913000010494', 'o30ur5JpAsAUyGBkR0uW4IxvahR8', 5198.00, '广东省广州市海珠区新港中路397号', '张三', '020-81167888', '2022-01-29 10:39:13', '2022-01-27 15:29:06', 2);
INSERT INTO `t_order` (`id`, `orderNo`, `userId`, `totalPrice`, `address`, `consignee`, `telNumber`, `createDate`, `payDate`, `status`) VALUES (94, 'JAVA20220129103913000011494', 'o30ur5JpAsAUyGBkR0uW4IxvahR8', 5198.00, '广东省广州市海珠区新港中路397号', '张三', '020-81167888', '2022-01-29 10:39:13', '2022-01-27 15:29:06', 2);
INSERT INTO `t_order` (`id`, `orderNo`, `userId`, `totalPrice`, `address`, `consignee`, `telNumber`, `createDate`, `payDate`, `status`) VALUES (95, 'JAVA20220129103913000012494', 'o30ur5JpAsAUyGBkR0uW4IxvahR8', 5198.00, '广东省广州市海珠区新港中路397号', '张三', '020-81167888', '2022-01-29 10:39:13', '2022-01-27 15:29:06', 2);
INSERT INTO `t_order` (`id`, `orderNo`, `userId`, `totalPrice`, `address`, `consignee`, `telNumber`, `createDate`, `payDate`, `status`) VALUES (96, 'JAVA20220129103913000013494', 'o30ur5JpAsAUyGBkR0uW4IxvahR8', 5198.00, '广东省广州市海珠区新港中路397号', '张三', '020-81167888', '2022-01-29 10:39:13', '2022-01-27 15:29:06', 3);
INSERT INTO `t_order` (`id`, `orderNo`, `userId`, `totalPrice`, `address`, `consignee`, `telNumber`, `createDate`, `payDate`, `status`) VALUES (97, 'JAVA20220129035805000000052', 'o30ur5JpAsAUyGBkR0uW4IxvahR8', 2599.00, '广东省广州市海珠区新港中路397号', '张三', '020-81167888', '2022-01-29 15:58:05', '2022-01-29 16:12:26', 2);
INSERT INTO `t_order` (`id`, `orderNo`, `userId`, `totalPrice`, `address`, `consignee`, `telNumber`, `createDate`, `payDate`, `status`) VALUES (98, 'JAVA20220129035946000000595', 'o30ur5JpAsAUyGBkR0uW4IxvahR8', 5198.00, '广东省广州市海珠区新港中路397号', '张三', '020-81167888', '2022-01-29 15:59:47', '2022-01-29 16:14:07', 2);
INSERT INTO `t_order` (`id`, `orderNo`, `userId`, `totalPrice`, `address`, `consignee`, `telNumber`, `createDate`, `payDate`, `status`) VALUES (99, 'JAVA20220129040547000000824', 'o30ur5JpAsAUyGBkR0uW4IxvahR8', 3799.00, '广东省广州市海珠区新港中路397号', '张三', '020-81167888', '2022-01-29 16:05:48', '2022-01-29 16:20:08', 2);
INSERT INTO `t_order` (`id`, `orderNo`, `userId`, `totalPrice`, `address`, `consignee`, `telNumber`, `createDate`, `payDate`, `status`) VALUES (100, 'JAVA20220129040836000000654', 'o30ur5JpAsAUyGBkR0uW4IxvahR8', 2599.00, '广东省广州市海珠区新港中路397号', '张三', '020-81167888', '2022-01-29 16:08:37', '2022-01-29 16:12:52', 3);
INSERT INTO `t_order` (`id`, `orderNo`, `userId`, `totalPrice`, `address`, `consignee`, `telNumber`, `createDate`, `payDate`, `status`) VALUES (101, 'JAVA20220129041124000000758', 'o30ur5JpAsAUyGBkR0uW4IxvahR8', 2599.00, '广东省广州市海珠区新港中路397号', '张三', '020-81167888', '2022-01-29 16:11:25', '2022-01-29 16:11:36', 2);
INSERT INTO `t_order` (`id`, `orderNo`, `userId`, `totalPrice`, `address`, `consignee`, `telNumber`, `createDate`, `payDate`, `status`) VALUES (102, 'JAVA20220129043412000000133', 'o30ur5JpAsAUyGBkR0uW4IxvahR8', 3799.00, '广东省广州市海珠区新港中路397号', '张三', '020-81167888', '2022-01-29 16:34:12', '2022-01-29 16:34:26', 2);
INSERT INTO `t_order` (`id`, `orderNo`, `userId`, `totalPrice`, `address`, `consignee`, `telNumber`, `createDate`, `payDate`, `status`) VALUES (106, 'JAVA20220221080859000000097', 'o30ur5JpAsAUyGBkR0uW4IxvahR8', 7497.00, '广东省广州市海珠区新港中路397号', '张三', '020-81167888', '2022-02-21 08:08:59', '2022-02-21 08:09:24', 2);
INSERT INTO `t_order` (`id`, `orderNo`, `userId`, `totalPrice`, `address`, `consignee`, `telNumber`, `createDate`, `payDate`, `status`) VALUES (107, 'JAVA20220221082558000000449', 'o30ur5JpAsAUyGBkR0uW4IxvahR8', 31794.00, '广东省广州市海珠区新港中路397号', '张三', '020-81167888', '2022-02-21 08:25:58', '2022-02-21 08:26:15', 3);
INSERT INTO `t_order` (`id`, `orderNo`, `userId`, `totalPrice`, `address`, `consignee`, `telNumber`, `createDate`, `payDate`, `status`) VALUES (108, 'JAVA20230115080236000000389', 'oaCrz4q-Qa6-ju-97vogQfBDBtWk', 7598.00, '广东省广州市海珠区新港中路397号', '张三', '020-81167888', '2023-01-15 20:02:36', '2023-01-15 20:02:36', 2);
INSERT INTO `t_order` (`id`, `orderNo`, `userId`, `totalPrice`, `address`, `consignee`, `telNumber`, `createDate`, `payDate`, `status`) VALUES (109, 'JAVA20230115082457000000320', 'oaCrz4q-Qa6-ju-97vogQfBDBtWk', 7598.00, '广东省广州市海珠区新港中路397号', '张三', '020-81167888', '2023-01-15 20:24:57', '2023-01-15 20:24:57', 3);
INSERT INTO `t_order` (`id`, `orderNo`, `userId`, `totalPrice`, `address`, `consignee`, `telNumber`, `createDate`, `payDate`, `status`) VALUES (110, 'JAVA20230115084745000000643', 'oaCrz4q-Qa6-ju-97vogQfBDBtWk', 7598.00, '广东省广州市海珠区新港中路397号', '张三', '020-81167888', '2023-01-15 20:47:46', '2023-01-15 20:47:46', 4);
INSERT INTO `t_order` (`id`, `orderNo`, `userId`, `totalPrice`, `address`, `consignee`, `telNumber`, `createDate`, `payDate`, `status`) VALUES (111, 'JAVA20230115085249000000583', 'oaCrz4q-Qa6-ju-97vogQfBDBtWk', 7598.00, '广东省广州市海珠区新港中路397号', '张三', '020-81167888', '2023-01-15 20:52:50', '2023-01-15 20:52:50', 2);
INSERT INTO `t_order` (`id`, `orderNo`, `userId`, `totalPrice`, `address`, `consignee`, `telNumber`, `createDate`, `payDate`, `status`) VALUES (112, 'JAVA20230115091701000000700', 'oaCrz4q-Qa6-ju-97vogQfBDBtWk', 4499.00, '广东省广州市海珠区新港中路397号', '张三', '020-81167888', '2023-01-15 21:17:02', '2023-01-15 21:17:02', 3);
INSERT INTO `t_order` (`id`, `orderNo`, `userId`, `totalPrice`, `address`, `consignee`, `telNumber`, `createDate`, `payDate`, `status`) VALUES (113, 'JAVA20230115111619000000468', 'oaCrz4q-Qa6-ju-97vogQfBDBtWk', 3799.00, '广东省广州市海珠区新港中路397号', '张三', '020-81167888', '2023-01-15 23:16:19', '2023-01-15 23:16:19', 4);
INSERT INTO `t_order` (`id`, `orderNo`, `userId`, `totalPrice`, `address`, `consignee`, `telNumber`, `createDate`, `payDate`, `status`) VALUES (115, 'JAVA20230116085155000000470', 'oaCrz4q-Qa6-ju-97vogQfBDBtWk', 2599.00, '广东省广州市海珠区新港中路397号', '张三', '020-81167888', '2023-01-16 08:51:55', '2023-01-16 08:51:55', 2);
INSERT INTO `t_order` (`id`, `orderNo`, `userId`, `totalPrice`, `address`, `consignee`, `telNumber`, `createDate`, `payDate`, `status`) VALUES (116, 'JAVA20230116102908000000744', 'oaCrz4q-Qa6-ju-97vogQfBDBtWk', 3799.00, '广东省广州市海珠区新港中路397号', '张三', '020-81167888', '2023-01-16 10:29:09', '2023-01-16 10:29:09', 2);
INSERT INTO `t_order` (`id`, `orderNo`, `userId`, `totalPrice`, `address`, `consignee`, `telNumber`, `createDate`, `payDate`, `status`) VALUES (120, 'JAVA20230202110207000000447', 'oaCrz4q-Qa6-ju-97vogQfBDBtWk', 3799.00, '广东省广州市海珠区新港中路397号', '张三', '020-81167888', '2023-02-02 11:02:07', '2023-02-02 11:02:07', 4);
INSERT INTO `t_order` (`id`, `orderNo`, `userId`, `totalPrice`, `address`, `consignee`, `telNumber`, `createDate`, `payDate`, `status`) VALUES (121, 'JAVA20230202045311000000715', 'oaCrz4q-Qa6-ju-97vogQfBDBtWk', 3799.00, '广东省广州市海珠区新港中路397号', '张三', '020-81167888', '2023-02-02 16:53:12', '2023-02-02 16:53:12', 1);
INSERT INTO `t_order` (`id`, `orderNo`, `userId`, `totalPrice`, `address`, `consignee`, `telNumber`, `createDate`, `payDate`, `status`) VALUES (122, 'JAVA20230207085510000000782', 'oaCrz4q-Qa6-ju-97vogQfBDBtWk', 1199.00, '广东省广州市海珠区新港中路397号', '张三', '020-81167888', '2023-02-07 08:55:11', '2023-02-07 09:12:48', 1);
INSERT INTO `t_order` (`id`, `orderNo`, `userId`, `totalPrice`, `address`, `consignee`, `telNumber`, `createDate`, `payDate`, `status`) VALUES (123, 'JAVA20230207091248000000056', 'oaCrz4q-Qa6-ju-97vogQfBDBtWk', 7598.00, '广东省广州市海珠区新港中路397号', '张三', '020-81167888', '2023-02-07 09:12:48', '2023-02-07 09:12:48', 4);
INSERT INTO `t_order` (`id`, `orderNo`, `userId`, `totalPrice`, `address`, `consignee`, `telNumber`, `createDate`, `payDate`, `status`) VALUES (124, 'JAVA20230207092258000000535', 'oaCrz4q-Qa6-ju-97vogQfBDBtWk', 3799.00, '广东省广州市海珠区新港中路397号', '张三', '020-81167888', '2023-02-07 09:22:59', '2023-02-07 09:22:59', 1);
INSERT INTO `t_order` (`id`, `orderNo`, `userId`, `totalPrice`, `address`, `consignee`, `telNumber`, `createDate`, `payDate`, `status`) VALUES (125, 'JAVA20230207092409000000712', 'oaCrz4q-Qa6-ju-97vogQfBDBtWk', 4499.00, '广东省广州市海珠区新港中路397号', '张三', '020-81167888', '2023-02-07 09:24:10', '2023-02-07 09:24:09', 1);
INSERT INTO `t_order` (`id`, `orderNo`, `userId`, `totalPrice`, `address`, `consignee`, `telNumber`, `createDate`, `payDate`, `status`) VALUES (126, 'JAVA20230210030008000000922', 'oaCrz4q-Qa6-ju-97vogQfBDBtWk', 3799.00, '广东省广州市海珠区新港中路397号', '张三', '020-81167888', '2023-02-10 15:00:09', '2023-02-10 15:00:08', 1);
INSERT INTO `t_order` (`id`, `orderNo`, `userId`, `totalPrice`, `address`, `consignee`, `telNumber`, `createDate`, `payDate`, `status`) VALUES (127, 'JAVA20230210031125000000640', 'oaCrz4q-Qa6-ju-97vogQfBDBtWk', 1399.00, '广东省广州市海珠区新港中路397号', '张三', '020-81167888', '2023-02-10 15:11:26', '2023-02-10 15:11:25', 1);
INSERT INTO `t_order` (`id`, `orderNo`, `userId`, `totalPrice`, `address`, `consignee`, `telNumber`, `createDate`, `payDate`, `status`) VALUES (128, 'JAVA20230210031650000000579', 'oaCrz4q-Qa6-ju-97vogQfBDBtWk', 7598.00, '广东省广州市海珠区新港中路397号', '张三', '020-81167888', '2023-02-10 15:16:51', '2023-02-10 15:16:50', 1);
INSERT INTO `t_order` (`id`, `orderNo`, `userId`, `totalPrice`, `address`, `consignee`, `telNumber`, `createDate`, `payDate`, `status`) VALUES (129, 'JAVA20230210033044000000721', 'oaCrz4q-Qa6-ju-97vogQfBDBtWk', 21095.00, '广东省广州市海珠区新港中路397号', '张三', '020-81167888', '2023-02-10 15:30:45', '2023-02-10 15:30:44', 1);
COMMIT;

-- ----------------------------
-- Table structure for t_order_detail
-- ----------------------------
DROP TABLE IF EXISTS `t_order_detail`;
CREATE TABLE `t_order_detail` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `mId` int(11) DEFAULT NULL COMMENT '订单主表ID',
  `goodsId` int(11) DEFAULT NULL COMMENT '商品ID',
  `goodsNumber` int(11) DEFAULT NULL COMMENT '商品购买数量',
  `goodsPrice` decimal(8,2) DEFAULT NULL COMMENT '商品单价',
  `goodsName` varchar(100) DEFAULT NULL COMMENT '商品名称',
  `goodsPic` varchar(255) DEFAULT NULL COMMENT '商品图片',
  PRIMARY KEY (`id`),
  KEY `mId` (`mId`),
  CONSTRAINT `t_order_detail_ibfk_1` FOREIGN KEY (`mId`) REFERENCES `t_order` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=165 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_order_detail
-- ----------------------------
BEGIN;
INSERT INTO `t_order_detail` (`id`, `mId`, `goodsId`, `goodsNumber`, `goodsPrice`, `goodsName`, `goodsPic`) VALUES (122, 83, 14, 2, 2599.00, 'Xiaomi Civi', '9.png');
INSERT INTO `t_order_detail` (`id`, `mId`, `goodsId`, `goodsNumber`, `goodsPrice`, `goodsName`, `goodsPic`) VALUES (123, 97, 14, 1, 2599.00, 'Xiaomi Civi', '9.png');
INSERT INTO `t_order_detail` (`id`, `mId`, `goodsId`, `goodsNumber`, `goodsPrice`, `goodsName`, `goodsPic`) VALUES (124, 98, 14, 2, 2599.00, 'Xiaomi Civi', '9.png');
INSERT INTO `t_order_detail` (`id`, `mId`, `goodsId`, `goodsNumber`, `goodsPrice`, `goodsName`, `goodsPic`) VALUES (125, 99, 4, 1, 3799.00, 'Xiaomi 11', '6.png');
INSERT INTO `t_order_detail` (`id`, `mId`, `goodsId`, `goodsNumber`, `goodsPrice`, `goodsName`, `goodsPic`) VALUES (126, 100, 14, 1, 2599.00, 'Xiaomi Civi', '9.png');
INSERT INTO `t_order_detail` (`id`, `mId`, `goodsId`, `goodsNumber`, `goodsPrice`, `goodsName`, `goodsPic`) VALUES (127, 101, 14, 1, 2599.00, 'Xiaomi Civi', '9.png');
INSERT INTO `t_order_detail` (`id`, `mId`, `goodsId`, `goodsNumber`, `goodsPrice`, `goodsName`, `goodsPic`) VALUES (128, 102, 4, 1, 3799.00, 'Xiaomi 11', '6.png');
INSERT INTO `t_order_detail` (`id`, `mId`, `goodsId`, `goodsNumber`, `goodsPrice`, `goodsName`, `goodsPic`) VALUES (135, 106, 5, 1, 2299.00, 'Redmi K40 游戏增强版', '11.png');
INSERT INTO `t_order_detail` (`id`, `mId`, `goodsId`, `goodsNumber`, `goodsPrice`, `goodsName`, `goodsPic`) VALUES (136, 106, 14, 2, 2599.00, 'Xiaomi Civi', '9.png');
INSERT INTO `t_order_detail` (`id`, `mId`, `goodsId`, `goodsNumber`, `goodsPrice`, `goodsName`, `goodsPic`) VALUES (137, 107, 14, 3, 2599.00, 'Xiaomi Civi', '9.png');
INSERT INTO `t_order_detail` (`id`, `mId`, `goodsId`, `goodsNumber`, `goodsPrice`, `goodsName`, `goodsPic`) VALUES (138, 107, 1, 2, 10999.00, '小米电视大师 82英寸', '21.png');
INSERT INTO `t_order_detail` (`id`, `mId`, `goodsId`, `goodsNumber`, `goodsPrice`, `goodsName`, `goodsPic`) VALUES (139, 107, 16, 1, 1999.00, '小米平板5', '13.png');
INSERT INTO `t_order_detail` (`id`, `mId`, `goodsId`, `goodsNumber`, `goodsPrice`, `goodsName`, `goodsPic`) VALUES (140, 108, 4, 2, 3799.00, 'Xiaomi 11', '6.png');
INSERT INTO `t_order_detail` (`id`, `mId`, `goodsId`, `goodsNumber`, `goodsPrice`, `goodsName`, `goodsPic`) VALUES (141, 109, 4, 2, 3799.00, 'Xiaomi 11', '6.png');
INSERT INTO `t_order_detail` (`id`, `mId`, `goodsId`, `goodsNumber`, `goodsPrice`, `goodsName`, `goodsPic`) VALUES (142, 110, 4, 2, 3799.00, 'Xiaomi 11', '6.png');
INSERT INTO `t_order_detail` (`id`, `mId`, `goodsId`, `goodsNumber`, `goodsPrice`, `goodsName`, `goodsPic`) VALUES (143, 111, 4, 2, 3799.00, 'Xiaomi 11', '6.png');
INSERT INTO `t_order_detail` (`id`, `mId`, `goodsId`, `goodsNumber`, `goodsPrice`, `goodsName`, `goodsPic`) VALUES (144, 112, 6, 1, 4499.00, 'Xiaomi 11 Pro', '1.png');
INSERT INTO `t_order_detail` (`id`, `mId`, `goodsId`, `goodsNumber`, `goodsPrice`, `goodsName`, `goodsPic`) VALUES (145, 113, 4, 1, 3799.00, 'Xiaomi 11', '6.png');
INSERT INTO `t_order_detail` (`id`, `mId`, `goodsId`, `goodsNumber`, `goodsPrice`, `goodsName`, `goodsPic`) VALUES (146, 115, 14, 1, 2599.00, 'Xiaomi Civi', '9.png');
INSERT INTO `t_order_detail` (`id`, `mId`, `goodsId`, `goodsNumber`, `goodsPrice`, `goodsName`, `goodsPic`) VALUES (147, 116, 4, 1, 3799.00, 'Xiaomi 11', '6.png');
INSERT INTO `t_order_detail` (`id`, `mId`, `goodsId`, `goodsNumber`, `goodsPrice`, `goodsName`, `goodsPic`) VALUES (151, 120, 4, 1, 3799.00, 'Xiaomi 11', '6.png');
INSERT INTO `t_order_detail` (`id`, `mId`, `goodsId`, `goodsNumber`, `goodsPrice`, `goodsName`, `goodsPic`) VALUES (152, 121, 4, 1, 3799.00, 'Xiaomi 11', '6.png');
INSERT INTO `t_order_detail` (`id`, `mId`, `goodsId`, `goodsNumber`, `goodsPrice`, `goodsName`, `goodsPic`) VALUES (153, 122, 8, 1, 1199.00, 'Note 9 5G', '3.png');
INSERT INTO `t_order_detail` (`id`, `mId`, `goodsId`, `goodsNumber`, `goodsPrice`, `goodsName`, `goodsPic`) VALUES (154, 123, 4, 2, 3799.00, 'Xiaomi 11', '6.png');
INSERT INTO `t_order_detail` (`id`, `mId`, `goodsId`, `goodsNumber`, `goodsPrice`, `goodsName`, `goodsPic`) VALUES (155, 124, 4, 1, 3799.00, 'Xiaomi 11', '6.png');
INSERT INTO `t_order_detail` (`id`, `mId`, `goodsId`, `goodsNumber`, `goodsPrice`, `goodsName`, `goodsPic`) VALUES (156, 125, 6, 1, 4499.00, 'Xiaomi 11 Pro', '1.png');
INSERT INTO `t_order_detail` (`id`, `mId`, `goodsId`, `goodsNumber`, `goodsPrice`, `goodsName`, `goodsPic`) VALUES (157, 126, 4, 1, 3799.00, 'Xiaomi 11', '6.png');
INSERT INTO `t_order_detail` (`id`, `mId`, `goodsId`, `goodsNumber`, `goodsPrice`, `goodsName`, `goodsPic`) VALUES (158, 127, 10, 1, 1399.00, 'Note 9 Pro 5G', '5.png');
INSERT INTO `t_order_detail` (`id`, `mId`, `goodsId`, `goodsNumber`, `goodsPrice`, `goodsName`, `goodsPic`) VALUES (159, 128, 4, 2, 3799.00, 'Xiaomi 11', '6.png');
INSERT INTO `t_order_detail` (`id`, `mId`, `goodsId`, `goodsNumber`, `goodsPrice`, `goodsName`, `goodsPic`) VALUES (160, 129, 4, 2, 3799.00, 'Xiaomi 11', '6.png');
INSERT INTO `t_order_detail` (`id`, `mId`, `goodsId`, `goodsNumber`, `goodsPrice`, `goodsName`, `goodsPic`) VALUES (161, 129, 6, 3, 4499.00, 'Xiaomi 11 Pro', '1.png');
COMMIT;

-- ----------------------------
-- Table structure for t_product
-- ----------------------------
DROP TABLE IF EXISTS `t_product`;
CREATE TABLE `t_product` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `name` varchar(100) DEFAULT NULL COMMENT '商品名称',
  `price` decimal(8,2) DEFAULT NULL COMMENT '商品价格',
  `num` int(11) DEFAULT '1',
  `stock` int(11) DEFAULT NULL COMMENT '库存',
  `proPic` varchar(255) DEFAULT 'default.jpg' COMMENT '商品图片',
  `isHot` bit(1) DEFAULT b'0' COMMENT '是否热门推荐商品',
  `isSwiper` bit(1) DEFAULT b'0' COMMENT '是否轮播图片商品',
  `swiperPic` varchar(255) DEFAULT 'default.jpg' COMMENT '商品轮播图片',
  `swiperSort` int(11) DEFAULT '0' COMMENT '轮播排序',
  `typeId` int(11) DEFAULT NULL COMMENT '商品类别编号',
  `hotDateTime` datetime DEFAULT NULL COMMENT '设置热卖日期',
  `productIntroImgs` varchar(2000) DEFAULT NULL COMMENT '商品介绍图片',
  `productParaImgs` varchar(2000) DEFAULT NULL COMMENT '商品规格参数图片',
  `description` varchar(2000) DEFAULT NULL COMMENT '商品描述',
  PRIMARY KEY (`id`),
  KEY `typeId` (`typeId`),
  CONSTRAINT `t_product_ibfk_1` FOREIGN KEY (`typeId`) REFERENCES `t_smalltype` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_product
-- ----------------------------
BEGIN;
INSERT INTO `t_product` (`id`, `name`, `price`, `num`, `stock`, `proPic`, `isHot`, `isSwiper`, `swiperPic`, `swiperSort`, `typeId`, `hotDateTime`, `productIntroImgs`, `productParaImgs`, `description`) VALUES (1, '小米电视大师 82英寸', 10999.00, 1, 3451, '21.png', b'1', b'0', '20230210042558000000486.JPG', 0, 14, '2023-02-10 16:01:34', '<img width=\'100%\' src=\'http://localhost:8081/image/productIntroImgs/1.jpg\'></img><img width=\'100%\' src=\'http://localhost:8081/image/productIntroImgs/2.jpg\'></img><img width=\'100%\' src=\'http://localhost:8081/image/productIntroImgs/3.jpg\'></img>', '<img width=\'100%\' src=\'http://localhost:8081/image/productParaImgs/1.jpg\'></img><img width=\'100%\' src=\'http://localhost:8081/image/productParaImgs/2.jpg\'></img>', '\"\"');
INSERT INTO `t_product` (`id`, `name`, `price`, `num`, `stock`, `proPic`, `isHot`, `isSwiper`, `swiperPic`, `swiperSort`, `typeId`, `hotDateTime`, `productIntroImgs`, `productParaImgs`, `description`) VALUES (4, 'Xiaomi 11', 3799.00, 10, 3232, '6.png', b'1', b'1', '3.jpg', 0, 2, '2023-02-10 16:34:02', '<img width=\'100%\' src=\'http://localhost:8081/image/productIntroImgs/11.jpg\'></img>', '<img width=\'100%\' src=\'http://localhost:8081/image/productParaImgs/11.jpg\'></img>', '「全版本领券立减200元，券后价3299元起；享至高24期免息；赠手机保护壳*1;【全款支付套装】赠果冻包」');
INSERT INTO `t_product` (`id`, `name`, `price`, `num`, `stock`, `proPic`, `isHot`, `isSwiper`, `swiperPic`, `swiperSort`, `typeId`, `hotDateTime`, `productIntroImgs`, `productParaImgs`, `description`) VALUES (5, 'Redmi K40 游戏增强版', 2299.00, 21, 2005, '11.png', b'1', b'1', '4.jpg', 1, 39, '2023-02-10 16:34:03', '<img width=\'100%\' src=\'http://localhost:8081/image/productIntroImgs/1.jpg\'></img><img width=\'100%\' src=\'http://localhost:8081/image/productIntroImgs/2.jpg\'></img><img width=\'100%\' src=\'http://localhost:8081/image/productIntroImgs/3.jpg\'></img>', '<img width=\'100%\' src=\'http://localhost:8081/image/productParaImgs/1.jpg\'></img><img width=\'100%\' src=\'http://localhost:8081/image/productParaImgs/2.jpg\'></img>', '\"\"');
INSERT INTO `t_product` (`id`, `name`, `price`, `num`, `stock`, `proPic`, `isHot`, `isSwiper`, `swiperPic`, `swiperSort`, `typeId`, `hotDateTime`, `productIntroImgs`, `productParaImgs`, `description`) VALUES (6, 'Xiaomi 11 Pro', 4499.00, 21, 2343, '1.png', b'1', b'1', '5.webp', 0, 2, '2023-02-10 16:34:03', '<img width=\'100%\' src=\'http://localhost:8081/image/productIntroImgs/1.jpg\'></img><img width=\'100%\' src=\'http://localhost:8081/image/productIntroImgs/2.jpg\'></img><img width=\'100%\' src=\'http://localhost:8081/image/productIntroImgs/3.jpg\'></img>', '<img width=\'100%\' src=\'http://localhost:8081/image/productParaImgs/1.jpg\'></img><img width=\'100%\' src=\'http://localhost:8081/image/productParaImgs/2.jpg\'></img>', NULL);
INSERT INTO `t_product` (`id`, `name`, `price`, `num`, `stock`, `proPic`, `isHot`, `isSwiper`, `swiperPic`, `swiperSort`, `typeId`, `hotDateTime`, `productIntroImgs`, `productParaImgs`, `description`) VALUES (7, 'Xiaomi MIX FOLD折叠屏手机', 7999.00, 21, 2222, '2.png', b'0', b'1', '6.webp', 0, 3, NULL, '<img width=\'100%\' src=\'http://localhost:8081/image/productIntroImgs/1.jpg\'></img><img width=\'100%\' src=\'http://localhost:8081/image/productIntroImgs/2.jpg\'></img><img width=\'100%\' src=\'http://localhost:8081/image/productIntroImgs/3.jpg\'></img>', '<img width=\'100%\' src=\'http://localhost:8081/image/productParaImgs/1.jpg\'></img><img width=\'100%\' src=\'http://localhost:8081/image/productParaImgs/2.jpg\'></img>', NULL);
INSERT INTO `t_product` (`id`, `name`, `price`, `num`, `stock`, `proPic`, `isHot`, `isSwiper`, `swiperPic`, `swiperSort`, `typeId`, `hotDateTime`, `productIntroImgs`, `productParaImgs`, `description`) VALUES (8, 'Note 9 5G', 1199.00, 10, 1111, '3.png', b'0', b'0', '6.webp', 0, 40, NULL, '<img width=\'100%\' src=\'http://localhost:8081/image/productIntroImgs/1.jpg\'></img><img width=\'100%\' src=\'http://localhost:8081/image/productIntroImgs/2.jpg\'></img><img width=\'100%\' src=\'http://localhost:8081/image/productIntroImgs/3.jpg\'></img>', '<img width=\'100%\' src=\'http://localhost:8081/image/productParaImgs/1.jpg\'></img><img width=\'100%\' src=\'http://localhost:8081/image/productParaImgs/2.jpg\'></img>', NULL);
INSERT INTO `t_product` (`id`, `name`, `price`, `num`, `stock`, `proPic`, `isHot`, `isSwiper`, `swiperPic`, `swiperSort`, `typeId`, `hotDateTime`, `productIntroImgs`, `productParaImgs`, `description`) VALUES (9, 'Xiaomi 10S', 2999.00, 10, 1111, '4.png', b'0', b'0', '6.webp', 0, 2, NULL, '<img width=\'100%\' src=\'http://localhost:8081/image/productIntroImgs/1.jpg\'></img><img width=\'100%\' src=\'http://localhost:8081/image/productIntroImgs/2.jpg\'></img><img width=\'100%\' src=\'http://localhost:8081/image/productIntroImgs/3.jpg\'></img>', '<img width=\'100%\' src=\'http://localhost:8081/image/productParaImgs/1.jpg\'></img><img width=\'100%\' src=\'http://localhost:8081/image/productParaImgs/2.jpg\'></img>', NULL);
INSERT INTO `t_product` (`id`, `name`, `price`, `num`, `stock`, `proPic`, `isHot`, `isSwiper`, `swiperPic`, `swiperSort`, `typeId`, `hotDateTime`, `productIntroImgs`, `productParaImgs`, `description`) VALUES (10, 'Note 9 Pro 5G', 1399.00, 10, 2222, '5.png', b'0', b'0', '6.webp', 0, 40, NULL, '<img width=\'100%\' src=\'http://localhost:8081/image/productIntroImgs/1.jpg\'></img><img width=\'100%\' src=\'http://localhost:8081/image/productIntroImgs/2.jpg\'></img><img width=\'100%\' src=\'http://localhost:8081/image/productIntroImgs/3.jpg\'></img>', '<img width=\'100%\' src=\'http://localhost:8081/image/productParaImgs/1.jpg\'></img><img width=\'100%\' src=\'http://localhost:8081/image/productParaImgs/2.jpg\'></img>', NULL);
INSERT INTO `t_product` (`id`, `name`, `price`, `num`, `stock`, `proPic`, `isHot`, `isSwiper`, `swiperPic`, `swiperSort`, `typeId`, `hotDateTime`, `productIntroImgs`, `productParaImgs`, `description`) VALUES (11, '黑鲨4', 2499.00, 10, 3322, '7.png', b'0', b'0', '6.webp', 0, 41, NULL, '<img width=\'100%\' src=\'http://localhost:8081/image/productIntroImgs/1.jpg\'></img><img width=\'100%\' src=\'http://localhost:8081/image/productIntroImgs/2.jpg\'></img><img width=\'100%\' src=\'http://localhost:8081/image/productIntroImgs/3.jpg\'></img>', '<img width=\'100%\' src=\'http://localhost:8081/image/productParaImgs/1.jpg\'></img><img width=\'100%\' src=\'http://localhost:8081/image/productParaImgs/2.jpg\'></img>', NULL);
INSERT INTO `t_product` (`id`, `name`, `price`, `num`, `stock`, `proPic`, `isHot`, `isSwiper`, `swiperPic`, `swiperSort`, `typeId`, `hotDateTime`, `productIntroImgs`, `productParaImgs`, `description`) VALUES (12, 'Redmi  K40 Pro 系列', 2499.00, 10, 3244, '8.png', b'0', b'0', '6.webp', 0, 39, NULL, '<img width=\'100%\' src=\'http://localhost:8081/image/productIntroImgs/1.jpg\'></img><img width=\'100%\' src=\'http://localhost:8081/image/productIntroImgs/2.jpg\'></img><img width=\'100%\' src=\'http://localhost:8081/image/productIntroImgs/3.jpg\'></img>', '<img width=\'100%\' src=\'http://localhost:8081/image/productParaImgs/1.jpg\'></img><img width=\'100%\' src=\'http://localhost:8081/image/productParaImgs/2.jpg\'></img>', NULL);
INSERT INTO `t_product` (`id`, `name`, `price`, `num`, `stock`, `proPic`, `isHot`, `isSwiper`, `swiperPic`, `swiperSort`, `typeId`, `hotDateTime`, `productIntroImgs`, `productParaImgs`, `description`) VALUES (14, 'Xiaomi Civi', 2599.00, 10, 4444, '9.png', b'0', b'0', '6.webp', 0, 1, NULL, '<img width=\'100%\' src=\'http://localhost:8081/image/productIntroImgs/1.jpg\'></img><img width=\'100%\' src=\'http://localhost:8081/image/productIntroImgs/2.jpg\'></img><img width=\'100%\' src=\'http://localhost:8081/image/productIntroImgs/3.jpg\'></img>', '<img width=\'100%\' src=\'http://localhost:8081/image/productParaImgs/1.jpg\'></img><img width=\'100%\' src=\'http://localhost:8081/image/productParaImgs/2.jpg\'></img>', '「购机至高享24期免息；赠Redmi AirDots 2真无线蓝牙耳机；赠Keep会员7天体验卡；+110元得Air2 SE蓝牙耳机」');
INSERT INTO `t_product` (`id`, `name`, `price`, `num`, `stock`, `proPic`, `isHot`, `isSwiper`, `swiperPic`, `swiperSort`, `typeId`, `hotDateTime`, `productIntroImgs`, `productParaImgs`, `description`) VALUES (15, 'Xiaomi 11 Ultra', 5499.00, 10, 4444, '10.png', b'0', b'0', '6.webp', 0, 2, NULL, '<img width=\'100%\' src=\'http://localhost:8081/image/productIntroImgs/1.jpg\'></img><img width=\'100%\' src=\'http://localhost:8081/image/productIntroImgs/2.jpg\'></img><img width=\'100%\' src=\'http://localhost:8081/image/productIntroImgs/3.jpg\'></img>', '<img width=\'100%\' src=\'http://localhost:8081/image/productParaImgs/1.jpg\'></img><img width=\'100%\' src=\'http://localhost:8081/image/productParaImgs/2.jpg\'></img>', NULL);
INSERT INTO `t_product` (`id`, `name`, `price`, `num`, `stock`, `proPic`, `isHot`, `isSwiper`, `swiperPic`, `swiperSort`, `typeId`, `hotDateTime`, `productIntroImgs`, `productParaImgs`, `description`) VALUES (16, '小米平板5', 1999.00, 10, 444, '13.png', b'0', b'0', '6.webp', 0, 5, NULL, '<img width=\'100%\' src=\'http://localhost:8081/image/productIntroImgs/1.jpg\'></img><img width=\'100%\' src=\'http://localhost:8081/image/productIntroImgs/2.jpg\'></img><img width=\'100%\' src=\'http://localhost:8081/image/productIntroImgs/3.jpg\'></img>', '<img width=\'100%\' src=\'http://localhost:8081/image/productParaImgs/1.jpg\'></img><img width=\'100%\' src=\'http://localhost:8081/image/productParaImgs/2.jpg\'></img>', '11英寸大屏 2.5K超清显示 120Hz高刷新率');
INSERT INTO `t_product` (`id`, `name`, `price`, `num`, `stock`, `proPic`, `isHot`, `isSwiper`, `swiperPic`, `swiperSort`, `typeId`, `hotDateTime`, `productIntroImgs`, `productParaImgs`, `description`) VALUES (17, '小米平板5 Pro', 2499.00, 10, 444, '14.png', b'0', b'0', '6.webp', 0, 5, NULL, '<img width=\'100%\' src=\'http://localhost:8081/image/productIntroImgs/1.jpg\'></img><img width=\'100%\' src=\'http://localhost:8081/image/productIntroImgs/2.jpg\'></img><img width=\'100%\' src=\'http://localhost:8081/image/productIntroImgs/3.jpg\'></img>', '<img width=\'100%\' src=\'http://localhost:8081/image/productParaImgs/1.jpg\'></img><img width=\'100%\' src=\'http://localhost:8081/image/productParaImgs/2.jpg\'></img>', NULL);
INSERT INTO `t_product` (`id`, `name`, `price`, `num`, `stock`, `proPic`, `isHot`, `isSwiper`, `swiperPic`, `swiperSort`, `typeId`, `hotDateTime`, `productIntroImgs`, `productParaImgs`, `description`) VALUES (19, 'RedmiBook Pro 15 增强版', 5299.00, 10, 444, '15.png', b'0', b'0', '6.webp', 0, 6, NULL, '<img width=\'100%\' src=\'http://localhost:8081/image/productIntroImgs/1.jpg\'></img><img width=\'100%\' src=\'http://localhost:8081/image/productIntroImgs/2.jpg\'></img><img width=\'100%\' src=\'http://localhost:8081/image/productIntroImgs/3.jpg\'></img>', '<img width=\'100%\' src=\'http://localhost:8081/image/productParaImgs/1.jpg\'></img><img width=\'100%\' src=\'http://localhost:8081/image/productParaImgs/2.jpg\'></img>', NULL);
INSERT INTO `t_product` (`id`, `name`, `price`, `num`, `stock`, `proPic`, `isHot`, `isSwiper`, `swiperPic`, `swiperSort`, `typeId`, `hotDateTime`, `productIntroImgs`, `productParaImgs`, `description`) VALUES (20, 'Redmi G 2021', 6499.00, 10, 1999, '16.png', b'0', b'0', '4.jpg', 2, 6, NULL, '<img width=\'100%\' src=\'http://localhost:8081/image/productIntroImgs/1.jpg\'></img><img width=\'100%\' src=\'http://localhost:8081/image/productIntroImgs/2.jpg\'></img><img width=\'100%\' src=\'http://localhost:8081/image/productIntroImgs/3.jpg\'></img>', '<img width=\'100%\' src=\'http://localhost:8081/image/productParaImgs/1.jpg\'></img><img width=\'100%\' src=\'http://localhost:8081/image/productParaImgs/2.jpg\'></img>', NULL);
INSERT INTO `t_product` (`id`, `name`, `price`, `num`, `stock`, `proPic`, `isHot`, `isSwiper`, `swiperPic`, `swiperSort`, `typeId`, `hotDateTime`, `productIntroImgs`, `productParaImgs`, `description`) VALUES (21, 'Redmi G 2021 锐龙版', 7499.00, 10, 2000, '17.png', b'0', b'0', '6.webp', 0, 6, NULL, '<img width=\'100%\' src=\'http://localhost:8081/image/productIntroImgs/1.jpg\'></img><img width=\'100%\' src=\'http://localhost:8081/image/productIntroImgs/2.jpg\'></img><img width=\'100%\' src=\'http://localhost:8081/image/productIntroImgs/3.jpg\'></img>', '<img width=\'100%\' src=\'http://localhost:8081/image/productParaImgs/1.jpg\'></img><img width=\'100%\' src=\'http://localhost:8081/image/productParaImgs/2.jpg\'></img>', NULL);
INSERT INTO `t_product` (`id`, `name`, `price`, `num`, `stock`, `proPic`, `isHot`, `isSwiper`, `swiperPic`, `swiperSort`, `typeId`, `hotDateTime`, `productIntroImgs`, `productParaImgs`, `description`) VALUES (22, 'RedmiBook Pro 14 增强版', 4999.00, 10, 777, '18.png', b'0', b'0', '6.webp', 0, 6, NULL, '<img width=\'100%\' src=\'http://localhost:8081/image/productIntroImgs/1.jpg\'></img><img width=\'100%\' src=\'http://localhost:8081/image/productIntroImgs/2.jpg\'></img><img width=\'100%\' src=\'http://localhost:8081/image/productIntroImgs/3.jpg\'></img>', '<img width=\'100%\' src=\'http://localhost:8081/image/productParaImgs/1.jpg\'></img><img width=\'100%\' src=\'http://localhost:8081/image/productParaImgs/2.jpg\'></img>', NULL);
INSERT INTO `t_product` (`id`, `name`, `price`, `num`, `stock`, `proPic`, `isHot`, `isSwiper`, `swiperPic`, `swiperSort`, `typeId`, `hotDateTime`, `productIntroImgs`, `productParaImgs`, `description`) VALUES (23, '小米笔记本 Pro 14 锐龙版', 5499.00, 10, 666, '19.png', b'0', b'0', '6.webp', 0, 7, NULL, '<img width=\'100%\' src=\'http://localhost:8081/image/productIntroImgs/1.jpg\'></img><img width=\'100%\' src=\'http://localhost:8081/image/productIntroImgs/2.jpg\'></img><img width=\'100%\' src=\'http://localhost:8081/image/productIntroImgs/3.jpg\'></img>', '<img width=\'100%\' src=\'http://localhost:8081/image/productParaImgs/1.jpg\'></img><img width=\'100%\' src=\'http://localhost:8081/image/productParaImgs/2.jpg\'></img>', NULL);
INSERT INTO `t_product` (`id`, `name`, `price`, `num`, `stock`, `proPic`, `isHot`, `isSwiper`, `swiperPic`, `swiperSort`, `typeId`, `hotDateTime`, `productIntroImgs`, `productParaImgs`, `description`) VALUES (24, '小米笔记本 Pro 14 增强版', 5499.00, 10, 666, '20.png', b'0', b'0', '6.webp', 0, 7, NULL, '<img width=\'100%\' src=\'http://localhost:8081/image/productIntroImgs/1.jpg\'></img><img width=\'100%\' src=\'http://localhost:8081/image/productIntroImgs/2.jpg\'></img><img width=\'100%\' src=\'http://localhost:8081/image/productIntroImgs/3.jpg\'></img>', '<img width=\'100%\' src=\'http://localhost:8081/image/productParaImgs/1.jpg\'></img><img width=\'100%\' src=\'http://localhost:8081/image/productParaImgs/2.jpg\'></img>', NULL);
INSERT INTO `t_product` (`id`, `name`, `price`, `num`, `stock`, `proPic`, `isHot`, `isSwiper`, `swiperPic`, `swiperSort`, `typeId`, `hotDateTime`, `productIntroImgs`, `productParaImgs`, `description`) VALUES (26, '1', 1.00, 10, 1, '20230210043419000000061.jpg', b'0', b'0', '20230210043425000000903.jpg', 3, 13, NULL, '<img width=\'100%\' src=\'http://localhost:8081/image/productIntroImgs/1.jpg\'></img><img width=\'100%\' src=\'http://localhost:8081/image/productIntroImgs/2.jpg\'></img><img width=\'100%\' src=\'http://localhost:8081/image/productIntroImgs/3.jpg\'></img>', '<img width=\'100%\' src=\'http://localhost:8081/image/productParaImgs/1.jpg\'></img><img width=\'100%\' src=\'http://localhost:8081/image/productParaImgs/2.jpg\'></img>', '555');
COMMIT;

-- ----------------------------
-- Table structure for t_product_swiper_image
-- ----------------------------
DROP TABLE IF EXISTS `t_product_swiper_image`;
CREATE TABLE `t_product_swiper_image` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `image` varchar(255) DEFAULT NULL COMMENT '图片',
  `sort` int(11) DEFAULT NULL COMMENT '排序',
  `productId` int(11) DEFAULT NULL COMMENT '所属商品id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_product_swiper_image
-- ----------------------------
BEGIN;
INSERT INTO `t_product_swiper_image` (`id`, `image`, `sort`, `productId`) VALUES (1, '1.jpg', 1, 14);
INSERT INTO `t_product_swiper_image` (`id`, `image`, `sort`, `productId`) VALUES (2, '2.jpg', 2, 14);
INSERT INTO `t_product_swiper_image` (`id`, `image`, `sort`, `productId`) VALUES (3, '3.jpg', 3, 14);
INSERT INTO `t_product_swiper_image` (`id`, `image`, `sort`, `productId`) VALUES (4, '4.jpg', 4, 14);
INSERT INTO `t_product_swiper_image` (`id`, `image`, `sort`, `productId`) VALUES (5, '5.jpg', 5, 14);
INSERT INTO `t_product_swiper_image` (`id`, `image`, `sort`, `productId`) VALUES (6, '6.jpg', 6, 14);
INSERT INTO `t_product_swiper_image` (`id`, `image`, `sort`, `productId`) VALUES (7, '7.jpg', 7, 14);
INSERT INTO `t_product_swiper_image` (`id`, `image`, `sort`, `productId`) VALUES (8, '11.jpg', 1, 4);
INSERT INTO `t_product_swiper_image` (`id`, `image`, `sort`, `productId`) VALUES (12, '111.jpg', 1, 16);
INSERT INTO `t_product_swiper_image` (`id`, `image`, `sort`, `productId`) VALUES (13, '222.jpg', 2, 16);
INSERT INTO `t_product_swiper_image` (`id`, `image`, `sort`, `productId`) VALUES (14, '333.jpg', 3, 16);
INSERT INTO `t_product_swiper_image` (`id`, `image`, `sort`, `productId`) VALUES (15, '1.jpg', 1, 6);
INSERT INTO `t_product_swiper_image` (`id`, `image`, `sort`, `productId`) VALUES (16, '2.jpg', 2, 6);
INSERT INTO `t_product_swiper_image` (`id`, `image`, `sort`, `productId`) VALUES (17, '3.jpg', 3, 6);
INSERT INTO `t_product_swiper_image` (`id`, `image`, `sort`, `productId`) VALUES (20, '20230121085058000000495.jpg', 1, 1);
INSERT INTO `t_product_swiper_image` (`id`, `image`, `sort`, `productId`) VALUES (21, '20230121085119000000141.jpg', 2, 1);
INSERT INTO `t_product_swiper_image` (`id`, `image`, `sort`, `productId`) VALUES (23, '20230210043447000000396.jpg', 11, 26);
COMMIT;

-- ----------------------------
-- Table structure for t_smalltype
-- ----------------------------
DROP TABLE IF EXISTS `t_smalltype`;
CREATE TABLE `t_smalltype` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `name` varchar(50) DEFAULT NULL COMMENT '商品小类',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `bigTypeId` int(11) DEFAULT NULL COMMENT '商品大类编号',
  PRIMARY KEY (`id`),
  KEY `bigTypeId` (`bigTypeId`),
  CONSTRAINT `t_smalltype_ibfk_1` FOREIGN KEY (`bigTypeId`) REFERENCES `t_bigtype` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=56 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_smalltype
-- ----------------------------
BEGIN;
INSERT INTO `t_smalltype` (`id`, `name`, `remark`, `bigTypeId`) VALUES (1, 'Xiaomi Civi', 'Xiaomi Civi', 1);
INSERT INTO `t_smalltype` (`id`, `name`, `remark`, `bigTypeId`) VALUES (2, 'Xiaomi 数字系列', 'Xiaomi 数字系列', 1);
INSERT INTO `t_smalltype` (`id`, `name`, `remark`, `bigTypeId`) VALUES (3, 'Xiaomi MIX系列', 'Xiaomi MIX系列', 1);
INSERT INTO `t_smalltype` (`id`, `name`, `remark`, `bigTypeId`) VALUES (5, '小米平板', '小米平板', 2);
INSERT INTO `t_smalltype` (`id`, `name`, `remark`, `bigTypeId`) VALUES (6, 'RedmiBook', 'RedmiBook', 2);
INSERT INTO `t_smalltype` (`id`, `name`, `remark`, `bigTypeId`) VALUES (7, '小米笔记本', '小米笔记本', 2);
INSERT INTO `t_smalltype` (`id`, `name`, `remark`, `bigTypeId`) VALUES (10, '耳机', '耳机', 3);
INSERT INTO `t_smalltype` (`id`, `name`, `remark`, `bigTypeId`) VALUES (11, '手表', '手表', 3);
INSERT INTO `t_smalltype` (`id`, `name`, `remark`, `bigTypeId`) VALUES (12, '手环', '手环', 3);
INSERT INTO `t_smalltype` (`id`, `name`, `remark`, `bigTypeId`) VALUES (13, '电视', '电视', 4);
INSERT INTO `t_smalltype` (`id`, `name`, `remark`, `bigTypeId`) VALUES (14, '小米电视大师', '小米电视大师', 4);
INSERT INTO `t_smalltype` (`id`, `name`, `remark`, `bigTypeId`) VALUES (15, '电视配件', '电视配件', 4);
INSERT INTO `t_smalltype` (`id`, `name`, `remark`, `bigTypeId`) VALUES (16, '空调', '空调', 5);
INSERT INTO `t_smalltype` (`id`, `name`, `remark`, `bigTypeId`) VALUES (17, '洗衣机', '洗衣机', 5);
INSERT INTO `t_smalltype` (`id`, `name`, `remark`, `bigTypeId`) VALUES (18, '冰箱', '冰箱', 5);
INSERT INTO `t_smalltype` (`id`, `name`, `remark`, `bigTypeId`) VALUES (19, '厨房大电', '厨房大电', 5);
INSERT INTO `t_smalltype` (`id`, `name`, `remark`, `bigTypeId`) VALUES (20, '厨房小电', '厨房小电', 6);
INSERT INTO `t_smalltype` (`id`, `name`, `remark`, `bigTypeId`) VALUES (21, '清洁电器', '清洁电器', 6);
INSERT INTO `t_smalltype` (`id`, `name`, `remark`, `bigTypeId`) VALUES (22, '环境电器', '环境电器', 6);
INSERT INTO `t_smalltype` (`id`, `name`, `remark`, `bigTypeId`) VALUES (23, '生活电器', '生活电器', 6);
INSERT INTO `t_smalltype` (`id`, `name`, `remark`, `bigTypeId`) VALUES (24, '小爱音箱', '小爱音箱', 7);
INSERT INTO `t_smalltype` (`id`, `name`, `remark`, `bigTypeId`) VALUES (25, '路由器', '路由器', 7);
INSERT INTO `t_smalltype` (`id`, `name`, `remark`, `bigTypeId`) VALUES (26, '智能安防', '智能安防', 7);
INSERT INTO `t_smalltype` (`id`, `name`, `remark`, `bigTypeId`) VALUES (27, '智能控制', '智能控制', 7);
INSERT INTO `t_smalltype` (`id`, `name`, `remark`, `bigTypeId`) VALUES (28, '户外出行', '户外出行', 8);
INSERT INTO `t_smalltype` (`id`, `name`, `remark`, `bigTypeId`) VALUES (29, '箱包', '箱包', 8);
INSERT INTO `t_smalltype` (`id`, `name`, `remark`, `bigTypeId`) VALUES (30, '家具日用', '家具日用', 9);
INSERT INTO `t_smalltype` (`id`, `name`, `remark`, `bigTypeId`) VALUES (31, '防护清洁', '防护清洁', 9);
INSERT INTO `t_smalltype` (`id`, `name`, `remark`, `bigTypeId`) VALUES (32, '会员定制', '会员定制', 9);
INSERT INTO `t_smalltype` (`id`, `name`, `remark`, `bigTypeId`) VALUES (33, '个人护理', '个人护理', 9);
INSERT INTO `t_smalltype` (`id`, `name`, `remark`, `bigTypeId`) VALUES (34, '健康', '健康', 9);
INSERT INTO `t_smalltype` (`id`, `name`, `remark`, `bigTypeId`) VALUES (35, '鞋服配饰', '鞋服配饰', 9);
INSERT INTO `t_smalltype` (`id`, `name`, `remark`, `bigTypeId`) VALUES (36, '床品家居', '床品家居', 9);
INSERT INTO `t_smalltype` (`id`, `name`, `remark`, `bigTypeId`) VALUES (37, '礼品周边', '礼品周边', 9);
INSERT INTO `t_smalltype` (`id`, `name`, `remark`, `bigTypeId`) VALUES (38, '儿童用品', '儿童用品', 10);
INSERT INTO `t_smalltype` (`id`, `name`, `remark`, `bigTypeId`) VALUES (39, 'Redmi K系列', 'K系列', 1);
INSERT INTO `t_smalltype` (`id`, `name`, `remark`, `bigTypeId`) VALUES (40, 'Redmi Note系列', 'Note系列', 1);
INSERT INTO `t_smalltype` (`id`, `name`, `remark`, `bigTypeId`) VALUES (41, '游戏手机', '游戏手机', 1);
INSERT INTO `t_smalltype` (`id`, `name`, `remark`, `bigTypeId`) VALUES (44, '22', '22', 3);
INSERT INTO `t_smalltype` (`id`, `name`, `remark`, `bigTypeId`) VALUES (45, '是', '3 是', 2);
INSERT INTO `t_smalltype` (`id`, `name`, `remark`, `bigTypeId`) VALUES (46, 'ewew', 'ew', 3);
INSERT INTO `t_smalltype` (`id`, `name`, `remark`, `bigTypeId`) VALUES (47, 'rrr', 'rrr', 2);
INSERT INTO `t_smalltype` (`id`, `name`, `remark`, `bigTypeId`) VALUES (48, '43', '4343', 2);
INSERT INTO `t_smalltype` (`id`, `name`, `remark`, `bigTypeId`) VALUES (53, '3215451', '2131', 12);
INSERT INTO `t_smalltype` (`id`, `name`, `remark`, `bigTypeId`) VALUES (54, '213123', '2131341', 12);
COMMIT;

-- ----------------------------
-- Table structure for t_wxuserinfo
-- ----------------------------
DROP TABLE IF EXISTS `t_wxuserinfo`;
CREATE TABLE `t_wxuserinfo` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户编号',
  `openid` varchar(30) DEFAULT NULL COMMENT '用户唯一标识',
  `nickName` varchar(50) DEFAULT NULL COMMENT '用户昵称',
  `avatarUrl` varchar(200) DEFAULT NULL COMMENT '用户头像图片的 URL',
  `registerDate` datetime DEFAULT NULL COMMENT '注册日期',
  `lastLoginDate` datetime DEFAULT NULL COMMENT '最后登录日期',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_wxuserinfo
-- ----------------------------
BEGIN;
INSERT INTO `t_wxuserinfo` (`id`, `openid`, `nickName`, `avatarUrl`, `registerDate`, `lastLoginDate`) VALUES (2, 'oaCrz4q-Qa6-ju-97vogQfBDBtWk', 'Meteor', 'https://up.qqmmgg.com/up/bb/dd/75/bbdd75fced6a649a7acbe9e321f4e13d.jpg', '2023-01-15 19:14:51', '2023-02-10 16:29:58');
INSERT INTO `t_wxuserinfo` (`id`, `openid`, `nickName`, `avatarUrl`, `registerDate`, `lastLoginDate`) VALUES (5, 'o30ur5JpAsAUyGBkR0uW4IxvahR8', '小锋一号@java1234', 'https://thirdwx.qlogo.cn/mmopen/vi_32/GJeHhQSiczuph0tg4JyleLeDUnIghqXlQBiaUAJMvia8GRSjibYdPmFQrvPic6sAhyTz4C8Ivu1aWah3KpFMBdsPibEw/132', '2022-01-08 22:19:11', '2022-02-21 08:20:09');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
